﻿CREATE TABLE [dbo].[ContentItem] (
    [Id]                  UNIQUEIDENTIFIER NOT NULL,
    [Name]                NVARCHAR (MAX)   NOT NULL,
    [PageId]              UNIQUEIDENTIFIER NOT NULL,
    [ContentTemplateId]   UNIQUEIDENTIFIER NOT NULL,
    [Deleted]             BIT              NOT NULL,
    [Properties]          NVARCHAR (MAX)   NULL,
    [Status]              INT              NOT NULL,
    [PublishedProperties] NVARCHAR (MAX)   NULL,
    [DateCreated]         DATETIME         NOT NULL,
    [DatePublished]       DATETIME         NULL,
    [Sequence]            INT              DEFAULT ((0)) NOT NULL
);











